home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d3
/
dprftmrg.arc
/
DPERFECT.DOC
< prev
next >
Wrap
Text File
|
1990-09-26
|
46KB
|
1,064 lines
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
dPerfect Merge
Converts data base files to Word Perfect secondary merge files
Copyright (c) 1990 Newdorf Research
1565 Regatta Road
Laguna Beach, CA 92651
Barbara J. Feldman
CompuServe ID: 73170,216
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
dPerfect Merge is a copyrighted SHAREWARE program. You are free to try this
program for thirty days and to distribute it freely to your friends and
associates. Please distribute the self-extracting archive file instead of
the individual files. If you use this program beyond the thirty day trial,
you are required to register your copy. If you include any part of dPerfect
Merge in a system for resale, you must register each copy of dPerfect Merge.
See Page 16 for registration details.
The complete dPerfect Merge package contains the following:
dPERFECT.EXE -- Interactive translation utility (Try this first!)
dPERFECT.DOC -- This documentation file
dPERF$$$.DBF -- Required configuration file
dPERFBV.EXE -- Batch translation utility (dPerfect BV)
dP_BTEST.BAT -- Sample batch program using dPerfect BV
dPERFECT.OBJ -- Clipper function for inclusion in Clipper programs
dP_CLIPP.PRG -- Sample Clipper program using dPERFECT.OBJ
dP_REGIS.TER -- Registration form
dP_READ.ME -- A list of files in the archive
This program is produced by a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware principle
works for you. If you are unable to resolve a shareware-related problem with
an ASP member by contacting the member directly, ASP may be able to help. The
ASP Ombudsman can help you resolve a dispute or problem with an ASP member,
but does not provide technical support for members' products. Please write to
the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006 or send a Compuserve
message via easyplex to ASP Ombudsman 70007,3536
Note: dBase is a registered trademark of Ashton-Tate. Word Perfect is a
registered trademark of WordPerfect Corp. Clipper is a registered trademark
of Nantucket Corp. FoxBase and FoxPro are registered trademarks of Fox
Software.
Page 1
dPerfect Merge
Table of Contents
CREATE MERGE FILE . . . . . . . . . . . . . . . . . . . . . . . . . Page 3
"Enter path and filename of source data base file:". . . . . . Page 3
"Enter key expression to create index:". . . . . . . . . . . . Page 3
"OR enter path and filename of existing index:" . . . . . . Page 4
"Enter path and filename of Word Perfect secondary merge file to be
created:" . . . . . . . . . . . . . . . . . . . . . . . . Page 4
"Enter record selection criteria:" . . . . . . . . . . . . . . Page 4
"There are ___ records that meet your criteria". . . . . . . . Page 4
"Mark fields to be included with the PLUS key:". . . . . . . . Page 5
"Want to save these parameters as a setup file? [Y/N]" . . . . Page 5
"Do you want to print a summary sheet? [Y/N]". . . . . . . . . Page 5
CHANGE dPERFECT MERGE CONFIGURATION . . . . . . . . . . . . . . . . Page 6
Default Configuration Parameters . . . . . . . . . . . . . . . Page 6
"Word Perfect Version:". . . . . . . . . . . . . . . . . . . . Page 6
"Date format:" . . . . . . . . . . . . . . . . . . . . . . . . Page 6
"Temporary Delimiter:" . . . . . . . . . . . . . . . . . . . . Page 6
"Logical Values:". . . . . . . . . . . . . . . . . . . . . . . Page 6
Use of the Configuration File. . . . . . . . . . . . . . . . . Page 6
REGISTRATION INFO . . . . . . . . . . . . . . . . . . . . . . . . . Page 7
"Name of Registered Owner:". . . . . . . . . . . . . . . . . . Page 7
"Registration Key:". . . . . . . . . . . . . . . . . . . . . . Page 7
CompuServe Offer . . . . . . . . . . . . . . . . . . . . . . . Page 7
USING dPERFECT MERGE. . . . . . . . . . . . . . . . . . . . . . . . Page 8
Using Setup Files. . . . . . . . . . . . . . . . . . . . . . . Page 8
Versions of Word Perfect Supported . . . . . . . . . . . . . . Page 8
Using Word Perfect Merge Files . . . . . . . . . . . . . . . . Page 8
Network Capabilities of dPerfect Merge . . . . . . . . . . . . Page 9
Use of the Tilde (~) Character . . . . . . . . . . . . . . . . Page 9
Working Disk Space Required. . . . . . . . . . . . . . . . . . Page 9
Minimum DOS Configuration Required . . . . . . . . . . . . . . Page 9
Index Key Expressions. . . . . . . . . . . . . . . . . . . . Page 10
Record Selection Criteria. . . . . . . . . . . . . . . . . . Page 11
BATCH VERSION OF dPERFECT MERGE . . . . . . . . . . . . . . . . . Page 12
Using the Batch Version of dPerfect (dPERFBV.EXE). . . . . . Page 12
Sample Batch File (dP_BTEST.BAT) . . . . . . . . . . . . . . Page 12
CLIPPER FUNCTION dPERFECT() . . . . . . . . . . . . . . . . . . . Page 13
dPerfect() Syntax. . . . . . . . . . . . . . . . . . . . . . Page 13
dPerfect() Arguments . . . . . . . . . . . . . . . . . . . . Page 13
dPerfect() Return Value. . . . . . . . . . . . . . . . . . . Page 13
dPerfect() Usage . . . . . . . . . . . . . . . . . . . . . . Page 13
Sample Clipper Program (dP_CLIPP.PRG). . . . . . . . . . . . Page 14
DEFINITION OF SHAREWARE . . . . . . . . . . . . . . . . . . . . . Page 15
DISCLAIMER - AGREEMENT. . . . . . . . . . . . . . . . . . . . . . Page 15
TO REGISTER YOUR COPY OF dPERFECT MERGE . . . . . . . . . . . . . Page 16
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 17
Page 2
dPerfect Merge
Converts data base files to Word Perfect secondary merge files
To start the program enter dPERFECT at the DOS command line. If you are
using a trial version, press any key to pass the registration screen (or you
will pause for 9 seconds). Answer each question followed by [Enter]. To
proceed without answering additional questions, use [F10] to continue. To
exit to the menu at any time, use [Esc]. To clear a response field, use
[Ctrl-Y]. To select a file from a directory listing, use [F2]. To select a
field name from a field list, use [F4].
CREATE MERGE FILE
"Enter path and filename of source data base file:"
This is the source data base from which your data will be read
and converted. This can be any valid dBase III Plus, Clipper,
Foxbase, Foxpro or compatible data base. Pathnames are
required if your data base is not in the current directory.
The ".DBF" extension is optional. If you enter a filename that
doesn't exist or is not a valid data base, you will not exit
from the field. This is a required field.
To view a directory listing use [F2]. Enter the directory
path you wish to view, including a DOS file skeleton using the
wildcard characters "?" or "*". To view all files use the
"*.*" skeleton. To view a listing of the current directory,
just press [Enter]. To scroll through the directory listing
use [Up arrow], [Down arrow], [Home] and [End]. To select a
file, use [Enter]. To exit from the directory listing without
selecting a file, use [Esc].
"Enter key expression to create index:"
This is an optional field. If you wish to dynamically create
an index for your data base, enter a single field name or a
compound key expression (e.g. STATE+CITY). Your merge file
will be sorted on this expression. For example, to create
mailing labels in zip code order, enter the zip code field
name from your data base. If you enter an invalid expression
or field name, you will not exit from this field. Memo and
logical fields are not allowed. To skip this question, press
[Enter]. For more examples, see "Key Index Expressions" on
Page 10
The index that is created is erased before exiting the
program. To select a field from a list of field names, use
[F4]. To scroll through the list use [Up arrow], [Down
arrow], [Home] and [End]. To select a field name from the
list, use [Enter]. To exit the list without selecting a
field, use [Esc].
Page 3
"OR enter path and filename of existing index:"
This is an optional field. If you wish to sort your merge
file on an existing dBase III compatible index, enter the name
of the index. You do not need to include the ".NDX"
extension. If you enter a filename that does not exist, you
will not exit this field. If you enter a filename that is not
a valid index, you will receive an error message. You cannot
enter both an index filename and a field to be indexed.
To view a directory listing use [F2]. Enter the directory
path you wish to view, including a DOS file skeleton using the
wildcard characters "?" or "*". To view all files use the
"*.*" skeleton. To view a listing of the current directory,
just press [Enter]. To scroll through the directory listing
use [Up arrow], [Down arrow], [Home] and [End]. To select a
file, use [Enter]. To exit the directory listing without
selecting a file, use [Esc].
"Enter path and filename of Word Perfect secondary merge file to be created:"
This is the name of the file to be created and is a required
field. If the file exists, you will be prompted with a
warning message. The file extension is optional. However, if
you do not specify an extension, ".SF" is used. The merge
file is created in Word Perfect 5.0 format (which also works
with WP 5.1) unless your configuration file specifies
otherwise. For more information on changing to a WP 4.2
format merge file, see "Change dPerfect Merge Configuration"
on Page 6. For more information on using this file to create
merge letters, see "Using Word Perfect Merge Files" on Page 8.
"Enter record selection criteria:"
This is an optional field. You may enter any valid dBase or
Clipper logical expression (up to 79 characters in length).
For example, you can use record selection to only convert
records for clients whose balance is greater than zero, or
only prospects from Tennessee. This is an advanced feature.
If you enter an illegal expression, you will receive an error
message. (See "Record Selection Criteria" on Page 11 for
examples and legal operators). To skip this field, just press
[Enter] and each record in your source data base file will be
converted to a record in the merge file.
To assist in creating your expression, you can use [F4] to
select from a list of field names. To scroll through the
list use [Up arrow], [Down arrow], [Home] and [End]. To
select from the list, use [Enter]. To exit without selecting
a field, use [Esc].
"There are ___ records that meet your criteria.
Do you wish to re-enter the criteria? [Y/N]"
To continue with the conversion, enter [N] or [F10]. If the
number of records doesn't seem correct, enter [Y] and verify
your responses and your record selection criteria.
Page 4
"Mark fields to be included with the PLUS key:"
Field names from your data base will be displayed. To include
a field in your Word Perfect merge file, use [+], otherwise
use [Space], [Enter], [Up arrow] or [Down arrow]. You must
mark at least one field. Memo fields are not supported and
will not appear in the field list or the merge file. The
default format for date fields is MM/DD/YY format (e.g.
04/30/90). Logical fields are converted to "Y" or "N". To
change the format of either dates or logical values, see
"Change dPerfect Merge Configuration" on Page 6.
"Want to save these parameters as a setup file? [Y/N]"
If you want to re-use these responses to create a merge file
at another time, (or to use with dPerfect BV) enter [Y]. You
will then be prompted for the name of the setup file. Do NOT
use an extension for the setup file -- dPerfect will save the
file with the extension ".MEM". You will be warned if the
setup file already exists. A setup file will save ALL of your
responses including:
1) Source data base file name
2) Expression to create index
3) File name of existing index
4) Word Perfect merge file name
5) Record selection criteria
6) Field selection
To use the setup file, see "Using Setup Files" on Page 8. A
setup file is required to use the batch version dPerfect BV
(see Batch Version of dPerfect Merge on Page 12).
"Do you want to print a summary sheet? [Y/N]"
A summary sheet will detail all of your responses and list
each field that you included along with its Word Perfect field
name (e.g. ^F1^,^F2^). This is a useful tool for creating
your Word Perfect primary merge file. The summary sheet is
printed to DOS port LPT1.
Page 5
CHANGE dPERFECT MERGE CONFIGURATION
To exit from the configuration screen without saving your changes, use [Esc]
at any time. To save your changes use [F10], or answer "Y" to "Save
Configuration". To return all values to the defaults, use [F5] followed by
[F10].
Default Configuration Parameters
Word Perfect Version: (1) WP 5.0 or greater
Date format: (1) MM/DD/YY
Temporary Delimiter: (1) tilde (~)
Logical Values: (1) Y/N
"Word Perfect Version:"
dPerfect Merge will create a 4.2 compatible merge file, if the
version parameter is set to (2) WP 4.2. Otherwise, the merge
file will be 5.0 format (which can also be used in 5.1). When
you first retrieve the merge file in 5.0 or 5.1, Word Perfect
will reformat for your default printer. In WP 5.1, you have
the option of converting the 5.0 merge codes into 5.1 format,
or using them without conversion.
"Date format:"
The default date format is "03/30/90". To change to European
format (e.g. "30/03/90") use option (2) DD/MM/YY. For dates
like "March 30, 1990" use option (3) Month DD, YYYY.
"Temporary Delimiter:"
dPerfect Merge uses a temporary delimiter to create the merge
files. The default is the tilde (~) character. If your data
base includes the use of the tilde, choose a delimiter that is
NOT in your data. Options are the carat (^) and the
horizontal bar (|).
"Logical Values:"
Logical values are converted to "Y" or "N" unless you specify
(2) YES/NO or (3) Yes/No.
Use of the Configuration File
dPerfect Merge uses dPERF$$$.DBF to save configuration
parameters and to coordinate the naming of temporary files for
multiple users. This file must be in the DOS path. If
multiple users on a network are not all using the same
configuration (e.g. different version of Word Perfect), each
user must have his own copy of dPERF$$$.DBF in his path. If
the configuration data base is erased or becomes corrupted,
restore it from your original distribution disk.
Page 6
REGISTRATION INFO
When you register your copy of dPerfect Merge (along with the latest version
of dPerfect Merge, a printed manual and 90 days of support) you will receive
a registration key. Input this key number along with your registration name
to bypass the initial registration screen. After you have entered your
registration info, your registration name will appear on the initial menu
screen.
For pricing and an order form see Page 16. For more information you can
contact us:
Newdorf Research
1565 Regatta Road
Laguna Beach, CA 92651
Barbara J. Feldman
CompuServe ID: 73170,216
"Name of Registered Owner:"
Enter your registration name (either an individual or a
company name) exactly as shown on your registration letter.
"Registration Key:"
Enter the registration key that is provided in your
registration letter. You will not exit this field unless you
have a valid registration key. To exit without a registration
key, leave the field empty.
CompuServe Offer
FREE!! -- when you register, you are entitled to a free
introductory subscription to CompuServe Information Service,
the biggest national on-line information data base and
service. You will receive a private user ID number and
password, a $15 usage credit (up to 2 1/2 hours connect time
at 300 baud), and a complimentary subscription to CompuServe's
monthly magazine.
Page 7
USING dPERFECT MERGE
Using Setup Files
To use a setup file, enter it as a / parameter to dPerfect on
the DOS command line. For example, to use setup file
ALLZIPS.MEM, start the program with:
dPERFECT /allzips
You will be given the opportunity to change any of your
responses. To continue without any changes, press [F10] three
times. A setup file will save ALL of your responses
including:
1) Source data base file name
2) Expression name to create index
3) File name of existing index
4) Word Perfect merge file name
5) Record selection criteria
6) Field selection
A setup file will not save the configuration parameters (such
as Word Perfect version, or data format). Setup files may be
used with the interactive version (dPERFECT.EXE) but are
required with the batch version (dPERFBV.EXE). They can not
be used with the Clipper function version (dPERFECT.OBJ). For
more information on creating setup files, see "Want to save
this parameters as a setup file?" on Page 5.
Versions of Word Perfect Supported
The default Word Perfect version is 5.0 (which also works on
5.1). To create a 4.2 compatible merge file, change the
dPerfect Merge configuration (from the main menu). Word
Perfect 5.1 gives you the option of either using 5.0 merge
files, or converting them to the 5.1 format. For more
information, see your Word Perfect reference manual.
Using Word Perfect Merge Files
dPerfect creates a Word Perfect secondary merge file. The
secondary file is the list of variable data (such as names,
addresses, phone numbers) that is merged with your fixed data
(primary file) to create form letters, mailing labels, etc.
To begin the merge from within Word Perfect, use [Ctrl F9]
[Merge] and name your secondary and primary files. If you use
Word Perfect 5.0 or 5.1 to edit your secondary merge file, you
may notice that Word Perfect will automatically reformat the
merge file to match your default printer. For additional
information, see your Word Perfect reference manual. Uses for
dPerfect Merge include:
1) Mailing labels
2) Personalized form letters
3) Data base publishing
4) Directories, lists, etc.
Page 8
Network Capabilities of dPerfect Merge
dPerfect Merge will operate in a network environment allowing
multiple users to access common data bases using record
locking. If your source data base is unavailable for shared
use, you will be given the opportunity to either retry or
exit. The configuration file dPERF$$$.DBF must be located in
the DOS path. This file is used to coordinate the naming of
temporary files among multiple users, and stores the
configuration parameters. If individual users need to have
different dPerfect Configuration parameters, place
dPERF$$$.DBF on a local or private drive. dPerfect Merge
requires Read/Write/Create/Delete privileges in the current
directory so that it may create and delete its temporary
files.
Use of the Tilde (~) Character
WARNING!! If your data contains the tilde (~) character,
dPerfect Merge MAY have trouble converting your data correctly
because the tilde is used as a temporary delimiting character
during the conversion. To resolve any conflicts, change the
delimiter character on the configuration screen.
Working Disk Space Required
dPerfect Merge requires approximately twice the space of the
merge file you wish to create. For example, if your data base
is 10 MB in length and you are converting 30% of your records
to a merge file, dPerfect will require 3 MB in temporary disk
space and 3 MB for your merge file -- totaling 6 MB.
Minimum DOS Configuration Required
dPerfect Merge requires DOS 3.1 or greater and 512Kb memory.
dPerfect Merge works on dBase III Plus, Clipper, FoxPro,
FoxBase or compatible data bases and supports "ndx" index
files. Clipper "ntx" index files are supported by the Clipper
function dPerfect() in dPERFECT.OBJ. dPerfect supports up to
1024 fields per data base. dPerfect creates secondary merge
files for either Word Perfect 4.2, or Word Perfect 5.0 (which
also work on WP 5.1). CONFIG.SYS must contain "Files=10" or
greater. For more information on CONFIG.SYS, consult your DOS
manual.
The configuration file dPERF$$$.DBF must be located in the DOS
path. This file is used to coordinate the naming of temporary
files among multiple users, and stores the configuration and
registration parameters. If individual users on a network need
to have different dPerfect Configuration parameters, place
dPERF$$$.DBF on a local or private drive.
Page 9
Index Key Expressions
Data
Operator Type Meaning Example
----------------------------------------------------------------------------
+ C Concatenation STATE+CITY
+ N Addition TAX+AMOUNT
+ D+N Adds days to date ORDER_DATE+AR_AGE
- D-N Subtracts days from date CLOSE_DATE-LEN_ESCRW
- D-D Elapsed days between dates SALE_DATE-LIST_DATE
DTOS() D Convert date to character DTOS(SALE_DATE)
STR() N Convert numeric to character STR(NUMBER)
VAL() C Convert character to numeric VAL(CHAR_AMT)
Be sure to consider the data type of your fields when creating a key index
expression. Use DTOS(date_field) to convert dates to character type suitable
for indexing. To create multiple level sorts, use concatenation. For
example, to sort by state, followed by city, followed by sold date, followed
by last name and first name:
STATE+CITY+DTOS(SOLD_DATE)+LAST_NAME+FIRST_NAME
Page 10
Record Selection Criteria
Data Record Selection
Operator Type Meaning Example
-------------------------------------------------------------------------
= C,N,D Equal to ZIPCODE="92561"
<> or # C,N,D Not equal to STATE <> "TX"
> C,N,D Greater than AMOUNT > 100
< C,N,D Less than AMOUNT < 100
>= C,N,D Greater than or equal to AMOUNT >= 100
<= C,N,D Less than or equal to AMOUNT <= 100
$ C Contained within PROD_TYPE $"1234"
.AND. L True if both expressions STATE="TX" .AND.
are true AMOUNT>100
.OR. L True if either expression STATE="TX" .OR.
is true AMOUNT>100
.NOT. L True if expression is false .NOT. STATE = "TX"
+ N Addition AMOUNT+TAX > 1000
+ C Concatenation FIRST+LAST="JOHNSMITH"
+ D+N Adds days to date ORDER_DATE+10 < DATE()
- N Subtraction GROSS-NET>10000
- D-N Subtracts days from date SHIP_DATE-10 <= ORDER_DATE
- D-D Elapsed time between dates SHIP_DATE-ORDER_DATE > 10
* N Multiplication AMOUNT*TAX_RATE > 1000
/ N Division TOT_AMT/AVG_PRICE > 10
Record selection criteria must be logical expressions -- expressions that
evaluate to either .T. (true) or .F. (false). In addition to the operators
listed above, any valid Clipper function may be used (e.g. !EMPTY(AMOUNT))
Be sure to use consider the data type of the fields that you are selecting.
The contents of data fields must be enclosed in quotes. For example, if
ZIPCODE is a character field:
ZIPCODE = 90304 Not a valid expression
ZIPCODE = "90304" Is a valid expression
Page 11
BATCH VERSION OF dPERFECT MERGE
The Batch Version of dPerfect Merge allows batch processing of your
conversion, and does not require any keyboard input. dPERFECT BV uses a setup
file to specify all the input parameters. It is designed to be called from a
DOS batch file, from a DOS menu or from any program that can run external
.EXE files. It allows a programmer to integrate dPerfect Merge into a
customized system, without having to train the end-user on dPerfect Merge.
dPERFBV will clear the screen before executing, and restore the original
screen upon exit.
Using the Batch Version of dPerfect (dPERFBV.EXE)
To create a setup file for dPerfect BV, first use the
interactive version (dPERFECT.EXE) and save your input as a
setup file. After the setup file has been saved, call dPERFBV
from the DOS command line or in a batch file. Remember, the
setup file is a required parameter. For example:
dPERFBV /setup
dPerfect BV sets the DOS ERRORLEVEL as follows:
ERRORLEVEL = 1 Successful completion
ERRORLEVEL = 2 Fatal error
If there is an error, the user is warned as to the type of
error -- and is prompted to "Press Return To Continue". This
is the only user input that is required. When there is a
successful completion, the user is returned to the calling
program (without requiring any user keystrokes).
WARNING: dPerfect BV does NOT warn before writing over an existing merge
file.
Sample Batch File (dP_BTEST.BAT):
ECHO OFF
CLS
ECHO This batch file assumes a setup file named "TEST"
ECHO otherwise, the merge file will not be generated.
PAUSE
dperfbv /test
CLS
IF ERRORLEVEL 2 GOTO no_wp
ECHO Creation of merge file successful!
ECHO Word Perfect can be started with a macro that
ECHO will do the merge. The following assumes that
ECHO the macro is named "MERGE".
PAUSE
wp /m-merge
GOTO end
:no_wp
ECHO An error prevented the creation of the merge file.
PAUSE
:end
Page 12
CLIPPER FUNCTION dPERFECT()
For Clipper programmers, dPerfect() is provided as an .OBJ object file to
include in your linkage.
dPerfect() Syntax
dPerfect("MERGE.SF", ARRAY)
dPerfect() Arguments
"MERGE.SF" is the filename of the merge file to be created --
be sure to include it in quotes.
ARRAY is the field selection array, indicating which fields
are to be included in the merge file. For a field to be
included, the corresponding array element must be "+". Any
other value, and the field will not be included in the merge
file. The ARRAY parameter is optional. If it is not
specified, all fields will be included in the merge file. See
the example below.
dPerfect() Return Value
dPerfect() returns the number of records that are translated
to the merge file, as well as setting the DOS errorlevel as
follows:
ERRORLEVEL () = 1 Successful completion
ERRORLEVEL () = 2 No merge file was specified
ERRORLEVEL () = 3 Configuration record busy
ERRORLEVEL () = 4 No records in source data base
ERRORLEVEL () = 5 No fields included in selection array
ERRORLEVEL () = 6 Temporary file busy
ERRORLEVEL () = 7 Cannot open/write/close merge file
dPerfect() Usage
Before calling the dPerfect() function, a data base must be
selected. Any indices or filters that are in use will be
reflected in the merge file. This provides for the use of
.NTX index files which are not supported in the interactive
(dPERFECT.EXE) or batch (dPERFBV.EXE) versions of dPerfect
Merge.
If "merge.sf" exists, it will be rewritten without warning.
There is no error trapping included in dPerfect(). Fatal
errors will be handled by Clipper (for example, if you are out
of disk space). Other errors will result in an ERRORLEVEL()
> 1. Upon exiting dPerfect(), your source data base will be
selected and the record pointer will be at TOP. The screen
and its original colors will be restored, the cursor will be
on and DATE will be set to either AMERICAN or BRITISH
(depending on the setting of your configuration file
dPERF$$$.DBF). This configuration file must be in the DOS
path. There is no user input required at any time during the
execution of dPerfect().
Page 13
Sample Clipper Program (dP_CLIPP.PRG):
* This assumes a database named "database",
* an index named "data_ntx", and a
* filter expression named "data_filtr"
SELECT A
USE database && select your data base
SET INDEX TO data_ntx && optional index
SET FILTER TO &data_filtr && optional filter
DECLARE array[FCOUNT()] && create optional array
AFILL (array,"+") && fill with pluses
array[1] = SPACE(1) && DO NOT translate 1st field
count = dPerfect("merge.sf",array) && create "merge.sf"
IF ERRORLEVEL() = 1 && successful completion
? STR(count) && display # records
ELSE
? "Sorry -- dPerfect Error!" && error occurred
ENDI
Page 14
DEFINITION OF SHAREWARE
Shareware distribution gives users a chance to try software before buying it.
If you try a Shareware program and continue using it, you are expected to
register. Copyright laws apply to both Shareware and commercial software,
and the copyright holder retains all rights, with a few specific exceptions
as stated below. Shareware authors are accomplished programmers, just like
commercial authors, and the programs are of comparable quality. (In both
cases, there are good programs and bad ones!) The main difference is in the
method of distribution. Shareware is a distribution method, not a type of
software. You should find software that suits your needs and pocketbook,
whether it's commercial or Shareware. The Shareware system makes fitting your
needs easier, because you can try before you buy. And because the overhead is
low, prices are low also. Shareware has the ultimate money-back guarantee --
if you don't use the product, you don't pay for it.
DISCLAIMER - AGREEMENT
Users of dPerfect Merge must accept this disclaimer of warranty: "dPerfect
Merge is supplied as is. The author disclaims all warranties, expressed or
implied, including, without limitation, the warranties of merchantability and
of fitness for any purpose. The author assumes no liability for damages,
direct or consequential, which may result from the use of dPerfect Merge."
dPerfect Merge is a "shareware program" and is provided at no charge to the
user for evaluation. Feel free to share the self-extracting archive file
with your friends, but please do not give it away altered or as part of
another system. The essence of "user-supported" software is to provide
personal computer users with quality software without high prices, and yet to
provide incentive for programmers to continue to develop new products.
If you find this program useful and find that you are using dPerfect Merge
and continue to use dPerfect Merge after a 30 day trial period, you must make
a registration payment of $24 to Newdorf Research. The $24 registration fee
will license one copy for use on any one computer at any one time. You must
treat this software just like a book. An example is that this software may
be used by any number of people and may be freely moved from one computer
location to another, so long as there is no possibility of it being used at
one location while it's being used at another. Just as a book cannot be read
by two different persons at the same time.
Commercial users of dPerfect Merge must register and pay for their copies of
dPerfect Merge within 30 days of first use or their license is withdrawn.
Site-License arrangements may be made by contacting Newdorf Research. Anyone
distributing dPerfect Merge for any kind of renumeration must first contact
Newdorf Research at the address below for authorization. This authorization
will be automatically granted to distributors recognized by the (ASP) as
adhering to its guidelines for shareware distributors, and such distributors
may begin offering dPerfect Merge immediately. (However Newdorf Research
must still be advised so that the distributor can be kept up-to-date with the
latest version of dPerfect Merge.)
You are encouraged to pass a copy of dPerfect Merge along to your friends for
evaluation. Please distribute the self-extracting archive file (rather than
individual files) and encourage them to register their copy if they find it
useful. All registered users will receive a copy of the latest version of
dPerfect Merge, a printed manual and a registration key that will bypass the
initial registration screen.
Page 15
TO REGISTER YOUR COPY OF dPERFECT MERGE
Receive the latest version of dPerfect Merge, a printed manual, 90 days of
support via phone, fax, mail or CompuServe -- AND you are entitled to a free
introductory CompuServe subscription and $15 usage credit.
NOTE: Your registered copies of dPerfect Merge will not display the
registration screen.
Site-License arrangements may be made by contacting Newdorf Research.
US Pricing US Pricing
Qty: 5 1/4" disk: 3 1/2" disk:
1-10 $24 $25
11-50 $22 $23
Disk Size: [ ] 5 1/4" [ ] 3 1/2"
Quantity:_________ X Price: $_____________ = Total $___________
California Sales Tax (6.25%) $___________
Mexico & Canada Shipping/Handling QTY ______ X $1.00 each $___________
Other FOREIGN Shipping/Handling QTY ______ X $4.00 each $___________
Total Enclosed $___________
Send check or money order (in US funds drawn on US bank, please)
To: Newdorf Research
1565 Regatta Road
Laguna Beach, CA 92651
Name of Registered Owner:_________________________________________
(list name or company exactly as you wish it to appear on the screen)
Contact Person:___________________________________________________
Company:__________________________________________________________
Address:___________________________________________________________
City:________________________________ State:_________Zip:__________
Phone: (______)___________________CompuServe User ID:______________
Where did you get your copy of dPerfect Merge?_____________________
Comments and Suggestions:__________________________________________
___________________________________________________________________
Page 16
INDEX
ASP . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 15
Batch Processing. . . . . . . . . . . . . . . . . . . . . . . . . . Page 12
Carat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Clipper . . . . . . . . . . . . . . . . . . . . . . . . . . Page 3, Page 13
CompuServe. . . . . . . . . . . . . . . . . . . . . . . . . .Page 1, Page 7
CONFIG.SYS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9
Configuration . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 8
Defaults . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
File . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 9
Control Keys
[Ctrl-Y] . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
[Esc]. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
[F10]. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
[F2] . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4
[F4] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
[F5] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Create Merge File . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Dates
European . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Formats. . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
dBase III Plus. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5
Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Delimiter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Carat. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Horizontal bar . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Tilde. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Directory Listing . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 4
Disk Space Required . . . . . . . . . . . . . . . . . . . . . . . . .Page 9
DOS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9
dP_BTEST.BAT. . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 12
dP_CLIPP.PRG. . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 14
dP_READ.ME. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
dPERF.EXE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
dPERF$$$.DBF. . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 9
dPERFBV.EXE . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 12
dPERFECT.OBJ. . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13
DPerfect(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13
Errorlevels . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 12
Expressions, logical. . . . . . . . . . . . . . . . . . . . . . . . Page 11
Fields. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5
Date . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5, Page 6
Field names. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Logical. . . . . . . . . . . . . . . . . . . . .Page 3, Page 5, Page 6
Memo . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3, Page 5
Filename Extensions . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
.DBF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
.MEM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5
.NDX . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 9
.SF. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Filenames . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 1
Filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 13
Horizontal Bar. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6
Page 17
Index. . . . . . . . . . . . . . . . . . . . . . . Page 3, Page 4, Page 13
Index Expression. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Key Expression. . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Logical Expressions . . . . . . . . . . . . . . . . . . . . . . . . Page 11
LPT1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5
Networks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 9
Operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 11
Print . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5
Record Selection. . . . . . . . . . . . . . . . . . . . . . Page 4, Page 11
Register dPerfect Merge . . . . . . . . . . . . . . . . . . . . . . Page 16
Registration key. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 7
Save Setup File . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5
Selection Criteria. . . . . . . . . . . . . . . . . . . . . . . . . .Page 4
Setup File. . . . . . . . . . . . . . . . . . . . . Page 5, Page 8, Page 12
Shareware . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 15
Sort. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Source data base. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 3
Summary Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 5
Support . . . . . . . . . . . . . . . . . . . . . . . . . . Page 1, Page 16
Tilde . . . . . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 9
Warranty. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Page 15
Word Perfect
4.2. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 6
5.0. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 6
5.1. . . . . . . . . . . . . . . . . . . . . . . . . . .Page 4, Page 6
Field Names (^F1^) . . . . . . . . . . . . . . . . . . . . . . .Page 5
Primary merge file . . . . . . . . . . . . . . . . . . . . . . .Page 5
Secondary merge file . . . . . . . . . . . . . . . . . .Page 4, Page 8
Versions . . . . . . . . . . . . . . . . . . . . . . . .Page 6, Page 8
Page 18